-- @author lixiyong01
-- @date 20240709
-- ods层movielens_links数据处理
-- set hive.support.concurrency=false;

use hdp_lbg_supin_zplisting;

insert overwrite table ods_hism_movielens_movies partition (dt='${RUNDATE}')
select
    items[0] as movie_id,
    items[1] as title,
    items[2] as genres
from (
    select split(content,',') as items
    from hdp_lbg_supin_zplisting.raw_hism_movielens_movies
    where dt = '${RUNDATE}'
) t;
